1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 |
<?php
#*********************************************************************
# Description:
# Updating data in a SQL Anywhere database can be
accomplished by
# performing a sasql_query() call to execute an UPDATE statement.
# The sasql_query() function prepares and executes the UPDATE statement
# identified by the connection that is passed in.
#
#*********************************************************************
# Connect using the default user ID
and password
$conn = sasql_connect ( "UID=DBA;PWD=sql" ) ;
if
( ! $conn ) {
echo
"Could not connect! \n " ;
echo sasql_error ( )
;
exit (
) ;
}
echo "Connected
successfully! \n "
;
# Execute an UPDATE statement
$stmt = 'UPDATE my_test_table SET message = \' updated \'
WHERE name =
\' John \' ' ;
$result = sasql_query ( $conn
, $stmt ) ;
#
Report any errors
if ( ! $result
) {
echo "sasql_query failed!" ;
} else {
echo "query
completed successfully \n
" ;
}
sasql_close ( $conn
) ;
?>
|
BACK : 技術情報（サンプルコード＆ユーティリティ）のトップページ
